package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DirectMailGoodsOrderDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DirectMailGoodsOrderDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DirectMailGoodsOrderDetailExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DirectMailGoodsOrderDetailExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DirectMailGoodsOrderDetailExample example = new DirectMailGoodsOrderDetailExample();
        return example.createCriteria();
    }

    public DirectMailGoodsOrderDetailExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DirectMailGoodsOrderDetailExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DirectMailGoodsOrderDetailExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderDetailExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderDetailExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andDetailIdIsNull() {
            addCriterion("directmailgoodsorderdetail.DetailId is null");
            return (Criteria) this;
        }

        public Criteria andDetailIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.DetailId is not null");
            return (Criteria) this;
        }

        public Criteria andDetailIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DetailId =", value, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DetailId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDetailIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DetailId <>", value, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DetailId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDetailIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.DetailId >", value, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DetailId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDetailIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DetailId >=", value, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DetailId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDetailIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.DetailId <", value, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DetailId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDetailIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DetailId <=", value, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DetailId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDetailIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.DetailId in", values, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.DetailId not in", values, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.DetailId between", value1, value2, "detailId");
            return (Criteria) this;
        }

        public Criteria andDetailIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.DetailId not between", value1, value2, "detailId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("directmailgoodsorderdetail.OrderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.OrderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.OrderId =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.OrderId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.OrderId <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.OrderId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.OrderId >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.OrderId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.OrderId >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.OrderId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.OrderId <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.OrderId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.OrderId <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.OrderId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.OrderId in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.OrderId not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.OrderId between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.OrderId not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNull() {
            addCriterion("directmailgoodsorderdetail.GoodsId is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.GoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.GoodsId =", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.GoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.GoodsId <>", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.GoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.GoodsId >", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.GoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.GoodsId >=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.GoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.GoodsId <", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.GoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.GoodsId <=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.GoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.GoodsId in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.GoodsId not in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.GoodsId between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.GoodsId not between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdIsNull() {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId is null");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId =", value, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailGoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId <>", value, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailGoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId >", value, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailGoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId >=", value, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailGoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId <", value, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailGoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId <=", value, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailGoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId in", values, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId not in", values, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId between", value1, value2, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andDirectMailGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.DirectMailGoodsId not between", value1, value2, "directMailGoodsId");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("directmailgoodsorderdetail.ProductId is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.ProductId is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ProductId =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ProductId <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.ProductId >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ProductId >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.ProductId <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ProductId <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.ProductId in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.ProductId not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.ProductId between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.ProductId not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdIsNull() {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId is null");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId is not null");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId =", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId <>", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId >", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId >=", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId <", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId <=", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.DirectMailProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId in", values, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId not in", values, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId between", value1, value2, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.DirectMailProductId not between", value1, value2, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("directmailgoodsorderdetail.`Name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("directmailgoodsorderdetail.`Name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`Name` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`Name` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`Name` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`Name` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`Name` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`Name` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("directmailgoodsorderdetail.`Name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.`Name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.`Name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.`Name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.`Name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIsNull() {
            addCriterion("directmailgoodsorderdetail.SpecNames is null");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIsNotNull() {
            addCriterion("directmailgoodsorderdetail.SpecNames is not null");
            return (Criteria) this;
        }

        public Criteria andSpecNamesEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames =", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.SpecNames = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames <>", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.SpecNames <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThan(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames >", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.SpecNames > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames >=", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.SpecNames >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThan(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames <", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.SpecNames < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames <=", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.SpecNames <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLike(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames like", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotLike(String value) {
            addCriterion("directmailgoodsorderdetail.SpecNames not like", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.SpecNames in", values, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.SpecNames not in", values, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.SpecNames between", value1, value2, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.SpecNames not between", value1, value2, "specNames");
            return (Criteria) this;
        }

        public Criteria andImageIsNull() {
            addCriterion("directmailgoodsorderdetail.Image is null");
            return (Criteria) this;
        }

        public Criteria andImageIsNotNull() {
            addCriterion("directmailgoodsorderdetail.Image is not null");
            return (Criteria) this;
        }

        public Criteria andImageEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.Image =", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Image = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageNotEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.Image <>", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Image <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThan(String value) {
            addCriterion("directmailgoodsorderdetail.Image >", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Image > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.Image >=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Image >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThan(String value) {
            addCriterion("directmailgoodsorderdetail.Image <", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Image < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.Image <=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Image <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLike(String value) {
            addCriterion("directmailgoodsorderdetail.Image like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotLike(String value) {
            addCriterion("directmailgoodsorderdetail.Image not like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.Image in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.Image not in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.Image between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.Image not between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andBuyNumberIsNull() {
            addCriterion("directmailgoodsorderdetail.BuyNumber is null");
            return (Criteria) this;
        }

        public Criteria andBuyNumberIsNotNull() {
            addCriterion("directmailgoodsorderdetail.BuyNumber is not null");
            return (Criteria) this;
        }

        public Criteria andBuyNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.BuyNumber =", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.BuyNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.BuyNumber <>", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.BuyNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.BuyNumber >", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.BuyNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.BuyNumber >=", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.BuyNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.BuyNumber <", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.BuyNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.BuyNumber <=", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.BuyNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.BuyNumber in", values, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.BuyNumber not in", values, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.BuyNumber between", value1, value2, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.BuyNumber not between", value1, value2, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("directmailgoodsorderdetail.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("directmailgoodsorderdetail.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNull() {
            addCriterion("directmailgoodsorderdetail.TotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNotNull() {
            addCriterion("directmailgoodsorderdetail.TotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TotalPrice =", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TotalPrice <>", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TotalPrice >", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TotalPrice >=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TotalPrice <", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TotalPrice <=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.TotalPrice in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.TotalPrice not in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.TotalPrice between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.TotalPrice not between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("directmailgoodsorderdetail.TaxRate is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("directmailgoodsorderdetail.TaxRate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxRate =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxRate = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxRate <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxRate <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxRate >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxRate > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxRate >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxRate >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxRate <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxRate < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxRate <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxRate <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.TaxRate in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.TaxRate not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.TaxRate between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.TaxRate not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIsNull() {
            addCriterion("directmailgoodsorderdetail.TaxPrice is null");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIsNotNull() {
            addCriterion("directmailgoodsorderdetail.TaxPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTaxPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxPrice =", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxPrice <>", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxPrice >", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxPrice >=", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxPrice <", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorderdetail.TaxPrice <=", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.TaxPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.TaxPrice in", values, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorderdetail.TaxPrice not in", values, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.TaxPrice between", value1, value2, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorderdetail.TaxPrice not between", value1, value2, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdIsNull() {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId is null");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId is not null");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId =", value, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.FreightTemplateId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId <>", value, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.FreightTemplateId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId >", value, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.FreightTemplateId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId >=", value, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.FreightTemplateId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId <", value, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.FreightTemplateId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId <=", value, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.FreightTemplateId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId in", values, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId not in", values, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId between", value1, value2, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andFreightTemplateIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.FreightTemplateId not between", value1, value2, "freightTemplateId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdIsNull() {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId is null");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdIsNotNull() {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId is not null");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId =", value, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ShippedRecordId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId <>", value, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ShippedRecordId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId >", value, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ShippedRecordId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId >=", value, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ShippedRecordId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdLessThan(Integer value) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId <", value, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ShippedRecordId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId <=", value, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.ShippedRecordId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId in", values, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId not in", values, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId between", value1, value2, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andShippedRecordIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorderdetail.ShippedRecordId not between", value1, value2, "shippedRecordId");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("directmailgoodsorderdetail.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("directmailgoodsorderdetail.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderdetail.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderdetail.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("directmailgoodsorderdetail.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderdetail.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("directmailgoodsorderdetail.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorderdetail.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("directmailgoodsorderdetail.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("directmailgoodsorderdetail.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorderdetail.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorderdetail.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("directmailgoodsorderdetail.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("directmailgoodsorderdetail.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("directmailgoodsorderdetail.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("directmailgoodsorderdetail.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderdetail.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderdetail.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderdetail.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderdetail.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderdetail.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderdetail.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("directmailgoodsorderdetail.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("directmailgoodsorderdetail.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("directmailgoodsorderdetail.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorderdetail.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorderdetail.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("directmailgoodsorderdetail.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("directmailgoodsorderdetail.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorderdetail.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorderdetail.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorderdetail.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DirectMailGoodsOrderDetail.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorderdetail.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorderdetail.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorderdetail.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderdetail.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorderdetail.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DirectMailGoodsOrderDetailExample example;

        protected Criteria(DirectMailGoodsOrderDetailExample example) {
            super();
            this.example = example;
        }

        public DirectMailGoodsOrderDetailExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DirectMailGoodsOrderDetail.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DirectMailGoodsOrderDetail.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.DirectMailGoodsOrderDetailExample example);
    }
}